---
title: "SQL-PTYP-01: Provider type by code"
summary: Retrieve a single provider type definition by its code
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-08-21
library: SAIF.Business.View.Provider
reference_type: embedded
---

# SQL-PTYP-01 Provider type by code

Retrieves a single `PROVIDER_TYPE_CODE` record by its code, returning the flags that drive
downstream behavior such as claim profile requirements, diagnosis requirement, mandatory MCO
enrollment, and self-registration eligibility.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-PTYP-01 |
| **Operation type** | Read |
| **Execution method** | Inline SQL (BOF criteria constant) |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsProviderType` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` / `AfterRetrieve` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:Code` | Input | String | 5 | `PROVIDER_TYPE_CODE.CODE` |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [PROVIDER_TYPE_CODE](../database-tables.md#provider_type_code) | SELECT | `CLAIM_PROFILE_FLAG`, `CODE`, `CODE_DESCR`, `DCBS_PROVIDER_TYPE_CODE`, `DIAGNOSIS_REQUIRED_FLAG`, `MANDATORY_MCO_FLAG`, `MEDICAL_AUDIT_FLAG`, `SELF_REGISTRATION_FLAG`, `SERVICE_PROV_RESTRICT_FLAG`, `UPDATE_DATE`, `UPDATE_NUM`, `UPDATE_USER` |

## Sample SQL

```sql
-- Provider type by code
SELECT
  PROVIDER_TYPE_CODE.CLAIM_PROFILE_FLAG          AS ClaimProfileFlag,
  PROVIDER_TYPE_CODE.CODE                        AS Code,
  PROVIDER_TYPE_CODE.CODE_DESCR                  AS CodeDescription,
  PROVIDER_TYPE_CODE.DCBS_PROVIDER_TYPE_CODE     AS DcbsProviderTypeCode,
  PROVIDER_TYPE_CODE.DIAGNOSIS_REQUIRED_FLAG     AS DiagnosisRequiredFlag,
  PROVIDER_TYPE_CODE.MANDATORY_MCO_FLAG          AS MandatoryMcoFlag,
  PROVIDER_TYPE_CODE.MEDICAL_AUDIT_FLAG          AS MedicalAuditFlag,
  PROVIDER_TYPE_CODE.SELF_REGISTRATION_FLAG      AS SelfRegistrationFlag,
  PROVIDER_TYPE_CODE.SERVICE_PROV_RESTRICT_FLAG  AS ServiceProvRestrictFlag,
  PROVIDER_TYPE_CODE.UPDATE_DATE                 AS UpdateDate,
  PROVIDER_TYPE_CODE.UPDATE_NUM                  AS UpdateNum,
  PROVIDER_TYPE_CODE.UPDATE_USER                 AS UpdateUser
FROM PROVIDER_TYPE_CODE
WHERE PROVIDER_TYPE_CODE.CODE = :Code
```

## Operations and processes
- [Load provider type](../operations/load-provider-type.md)

## Business rules
- [BR-PLOC-003: Valid provider type code](../business-rules.md#br-ploc-003-provider-type-code-must-be-non-empty)

## Sources
- SAIF.Business.View.Provider/clsProviderType.vb